{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='长城')|(price['brand']=='哈弗')|(price['brand']=='WEY')]\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LGW')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "轴距[mm]  长×宽×高[mm]       brand  style\n",
       "2680    4600x1860x1720  哈弗     哈弗H6     13\n",
       "        4610x1860x1720  哈弗     哈弗H6      3\n",
       "        4640x1825x1690  哈弗     哈弗H6     75\n",
       "        4649x1852x1710  哈弗     哈弗H6     23\n",
       "        4649x1852x1727  哈弗     哈弗H6      2\n",
       "        4681x1827x1710  哈弗     哈弗H6      3\n",
       "2700    4645x1800x1775  哈弗     哈弗H5      9\n",
       "        4645x1800x1785  哈弗     哈弗H5      5\n",
       "        4649x1810x1735  哈弗     哈弗H5     19\n",
       "        4649x1810x1745  哈弗     哈弗H5     25\n",
       "        4650x1800x1745  哈弗     哈弗H5     26\n",
       "        4650x1800x1755  哈弗     哈弗H5     30\n",
       "Name: factory, dtype: int64"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price[(LSG_price['style']=='哈弗H6')|(LSG_price['style']=='哈弗H5')].groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CC7203UM02A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1709,1675</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWEE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CC7203UM22A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1784</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWFE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CC7203UM02A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1709,1675</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWEE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CC7203UM02A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1709,1675</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWEE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CC7153UM07A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1625,1645</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1499</td>\n",
       "      <td>124</td>\n",
       "      <td>LGWEE5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CC7153UM07A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1625,1645</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1499</td>\n",
       "      <td>124</td>\n",
       "      <td>LGWEE5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CC7203UM02A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1709,1675</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWEE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CC7152UM0A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1625,1645</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1499</td>\n",
       "      <td>124</td>\n",
       "      <td>LGWEE5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CC7202UM23</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1784</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWFE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CC7203UM22A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1784</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWFE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CC7203UM02A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1709,1675</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWEE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CC7152UM0A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1625,1645</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1499</td>\n",
       "      <td>124</td>\n",
       "      <td>LGWEE5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CC7153UM07A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1625,1645</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1499</td>\n",
       "      <td>124</td>\n",
       "      <td>LGWEE5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CC7203UM02A</td>\n",
       "      <td>魏派</td>\n",
       "      <td>1709</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462</td>\n",
       "      <td>1857</td>\n",
       "      <td>1638</td>\n",
       "      <td>1967</td>\n",
       "      <td>145</td>\n",
       "      <td>LGWEE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2680</td>\n",
       "      <td>4462x1857x1638</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CC7151FM0G</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1541</td>\n",
       "      <td>2560</td>\n",
       "      <td>4365</td>\n",
       "      <td>1814</td>\n",
       "      <td>1695</td>\n",
       "      <td>1497</td>\n",
       "      <td>110</td>\n",
       "      <td>LGWEE4A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2560</td>\n",
       "      <td>4365x1814x1695</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H2</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CC7151BMA0R</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CC7151BMA0P</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CC7151BMA0K</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CC7151BMA0M</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CC7151BMA0P</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>CC7151BMA0R</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>CC7151BMA0M</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>CC7151BMA0P</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CC7151BMA0K</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>CC7151BMA0R</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>CC7151BMA0P</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>CC7151BMA0K</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CC7151BMA0R</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CC7151BMA0M</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CC7151BMA0R</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1145,1185</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898</td>\n",
       "      <td>1729</td>\n",
       "      <td>1621</td>\n",
       "      <td>1497</td>\n",
       "      <td>78</td>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2460</td>\n",
       "      <td>3898x1729x1621</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>CC6480TM2B</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>2175</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>CC6480TM0B</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>2098</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>CC6480TM20</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>2130,2175</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>CC6480TM00</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>2053,2098</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>CC6480TM24</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>2130</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>CC6480TM04</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>2053</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>CC6480TM2B</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>2175</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>CC6480TM0B</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>2098</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>CC6480TM0B</td>\n",
       "      <td>长城</td>\n",
       "      <td>2098</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>CC6480TM00</td>\n",
       "      <td>长城</td>\n",
       "      <td>2053,2098</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>CC6480TM20</td>\n",
       "      <td>长城</td>\n",
       "      <td>2130,2175</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>CC6480TM2B</td>\n",
       "      <td>长城</td>\n",
       "      <td>2175</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>CC6480TM04</td>\n",
       "      <td>长城</td>\n",
       "      <td>2053</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>CC6480TM20</td>\n",
       "      <td>长城</td>\n",
       "      <td>2130</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>CC6480TM00</td>\n",
       "      <td>长城</td>\n",
       "      <td>2053</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>CC6480TM24</td>\n",
       "      <td>长城</td>\n",
       "      <td>2130</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>CC6480TM04</td>\n",
       "      <td>长城</td>\n",
       "      <td>2053</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>CC6480TM20</td>\n",
       "      <td>长城</td>\n",
       "      <td>2130</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>CC6480TM00</td>\n",
       "      <td>长城</td>\n",
       "      <td>2053</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>CC6480TM24</td>\n",
       "      <td>长城</td>\n",
       "      <td>2130</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>CC6480TM04</td>\n",
       "      <td>长城</td>\n",
       "      <td>2053</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>CC6480TM00</td>\n",
       "      <td>长城</td>\n",
       "      <td>2053</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>471</th>\n",
       "      <td>CC6480TM24</td>\n",
       "      <td>长城</td>\n",
       "      <td>2130</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>472</th>\n",
       "      <td>CC6480TM20</td>\n",
       "      <td>长城</td>\n",
       "      <td>2130</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>CC6480TM20</td>\n",
       "      <td>长城</td>\n",
       "      <td>2130</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>474</th>\n",
       "      <td>CC6480TM00</td>\n",
       "      <td>长城</td>\n",
       "      <td>2053</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806</td>\n",
       "      <td>1975</td>\n",
       "      <td>1794</td>\n",
       "      <td>1967</td>\n",
       "      <td>160</td>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2915</td>\n",
       "      <td>4806x1975x1794</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>CC6461KM0K</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1740</td>\n",
       "      <td>2700</td>\n",
       "      <td>4650</td>\n",
       "      <td>1800</td>\n",
       "      <td>1755</td>\n",
       "      <td>1997</td>\n",
       "      <td>140</td>\n",
       "      <td>LGWEF5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2700</td>\n",
       "      <td>4650x1800x1755</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H5</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>476</th>\n",
       "      <td>CC6461KM0K</td>\n",
       "      <td>长城</td>\n",
       "      <td>1740</td>\n",
       "      <td>2700</td>\n",
       "      <td>4650</td>\n",
       "      <td>1800</td>\n",
       "      <td>1755</td>\n",
       "      <td>1997</td>\n",
       "      <td>140</td>\n",
       "      <td>LGWEF5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2700</td>\n",
       "      <td>4650x1800x1755</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H5</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>CC6461KM2K</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>1830</td>\n",
       "      <td>2700</td>\n",
       "      <td>4650</td>\n",
       "      <td>1800</td>\n",
       "      <td>1745</td>\n",
       "      <td>1997</td>\n",
       "      <td>140</td>\n",
       "      <td>LGWFF5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2700</td>\n",
       "      <td>4650x1800x1745</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H5</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478</th>\n",
       "      <td>CC6461KM2K</td>\n",
       "      <td>长城</td>\n",
       "      <td>1830</td>\n",
       "      <td>2700</td>\n",
       "      <td>4650</td>\n",
       "      <td>1800</td>\n",
       "      <td>1745</td>\n",
       "      <td>1997</td>\n",
       "      <td>140</td>\n",
       "      <td>LGWFF5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>LGW</td>\n",
       "      <td>2700</td>\n",
       "      <td>4650x1800x1745</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H5</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>479 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0    CC7203UM02A      魏派   1709,1675      2680       4462      1857   \n",
       "1    CC7203UM22A      魏派        1784      2680       4462      1857   \n",
       "2    CC7203UM02A      魏派   1709,1675      2680       4462      1857   \n",
       "3    CC7203UM02A      魏派   1709,1675      2680       4462      1857   \n",
       "4    CC7153UM07A      魏派   1625,1645      2680       4462      1857   \n",
       "5    CC7153UM07A      魏派   1625,1645      2680       4462      1857   \n",
       "6    CC7203UM02A      魏派   1709,1675      2680       4462      1857   \n",
       "7     CC7152UM0A      魏派   1625,1645      2680       4462      1857   \n",
       "8     CC7202UM23      魏派        1784      2680       4462      1857   \n",
       "9    CC7203UM22A      魏派        1784      2680       4462      1857   \n",
       "10   CC7203UM02A      魏派   1709,1675      2680       4462      1857   \n",
       "11    CC7152UM0A      魏派   1625,1645      2680       4462      1857   \n",
       "12   CC7153UM07A      魏派   1625,1645      2680       4462      1857   \n",
       "13   CC7203UM02A      魏派        1709      2680       4462      1857   \n",
       "14    CC7151FM0G      哈弗        1541      2560       4365      1814   \n",
       "15   CC7151BMA0R      哈弗   1145,1185      2460       3898      1729   \n",
       "16   CC7151BMA0P      哈弗   1145,1185      2460       3898      1729   \n",
       "17   CC7151BMA0K      哈弗   1145,1185      2460       3898      1729   \n",
       "18   CC7151BMA0M      哈弗   1145,1185      2460       3898      1729   \n",
       "19   CC7151BMA0P      哈弗   1145,1185      2460       3898      1729   \n",
       "20   CC7151BMA0R      哈弗   1145,1185      2460       3898      1729   \n",
       "21   CC7151BMA0M      哈弗   1145,1185      2460       3898      1729   \n",
       "22   CC7151BMA0P      哈弗   1145,1185      2460       3898      1729   \n",
       "23   CC7151BMA0K      哈弗   1145,1185      2460       3898      1729   \n",
       "24   CC7151BMA0R      哈弗   1145,1185      2460       3898      1729   \n",
       "25   CC7151BMA0P      哈弗   1145,1185      2460       3898      1729   \n",
       "26   CC7151BMA0K      哈弗   1145,1185      2460       3898      1729   \n",
       "27   CC7151BMA0R      哈弗   1145,1185      2460       3898      1729   \n",
       "28   CC7151BMA0M      哈弗   1145,1185      2460       3898      1729   \n",
       "29   CC7151BMA0R      哈弗   1145,1185      2460       3898      1729   \n",
       "..           ...     ...         ...       ...        ...       ...   \n",
       "449   CC6480TM2B      哈弗        2175      2915       4806      1975   \n",
       "450   CC6480TM0B      哈弗        2098      2915       4806      1975   \n",
       "451   CC6480TM20      哈弗   2130,2175      2915       4806      1975   \n",
       "452   CC6480TM00      哈弗   2053,2098      2915       4806      1975   \n",
       "453   CC6480TM24      哈弗        2130      2915       4806      1975   \n",
       "454   CC6480TM04      哈弗        2053      2915       4806      1975   \n",
       "455   CC6480TM2B      哈弗        2175      2915       4806      1975   \n",
       "456   CC6480TM0B      哈弗        2098      2915       4806      1975   \n",
       "457   CC6480TM0B      长城        2098      2915       4806      1975   \n",
       "458   CC6480TM00      长城   2053,2098      2915       4806      1975   \n",
       "459   CC6480TM20      长城   2130,2175      2915       4806      1975   \n",
       "460   CC6480TM2B      长城        2175      2915       4806      1975   \n",
       "461   CC6480TM04      长城        2053      2915       4806      1975   \n",
       "462   CC6480TM20      长城        2130      2915       4806      1975   \n",
       "463   CC6480TM00      长城        2053      2915       4806      1975   \n",
       "464   CC6480TM24      长城        2130      2915       4806      1975   \n",
       "465   CC6480TM04      长城        2053      2915       4806      1975   \n",
       "466   CC6480TM20      长城        2130      2915       4806      1975   \n",
       "467   CC6480TM00      长城        2053      2915       4806      1975   \n",
       "468   CC6480TM24      长城        2130      2915       4806      1975   \n",
       "469   CC6480TM04      长城        2053      2915       4806      1975   \n",
       "470   CC6480TM00      长城        2053      2915       4806      1975   \n",
       "471   CC6480TM24      长城        2130      2915       4806      1975   \n",
       "472   CC6480TM20      长城        2130      2915       4806      1975   \n",
       "473   CC6480TM20      长城        2130      2915       4806      1975   \n",
       "474   CC6480TM00      长城        2053      2915       4806      1975   \n",
       "475   CC6461KM0K      哈弗        1740      2700       4650      1800   \n",
       "476   CC6461KM0K      长城        1740      2700       4650      1800   \n",
       "477   CC6461KM2K      哈弗        1830      2700       4650      1800   \n",
       "478   CC6461KM2K      长城        1830      2700       4650      1800   \n",
       "\n",
       "    car_height Displacement power                vin car_factory    3 轴距[mm]  \\\n",
       "0         1638         1967   145  LGWEE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "1         1638         1967   145  LGWFE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "2         1638         1967   145  LGWEE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "3         1638         1967   145  LGWEE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "4         1638         1499   124  LGWEE5A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "5         1638         1499   124  LGWEE5A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "6         1638         1967   145  LGWEE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "7         1638         1499   124  LGWEE5A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "8         1638         1967   145  LGWFE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "9         1638         1967   145  LGWFE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "10        1638         1967   145  LGWEE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "11        1638         1499   124  LGWEE5A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "12        1638         1499   124  LGWEE5A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "13        1638         1967   145  LGWEE6A5×××××××××  长城汽车股份有限公司  LGW   2680   \n",
       "14        1695         1497   110  LGWEE4A4×××××××××  长城汽车股份有限公司  LGW   2560   \n",
       "15        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "16        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "17        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "18        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "19        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "20        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "21        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "22        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "23        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "24        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "25        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "26        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "27        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "28        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "29        1621         1497    78  LGWED2A4×××××××××  长城汽车股份有限公司  LGW   2460   \n",
       "..         ...          ...   ...                ...         ...  ...    ...   \n",
       "449       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "450       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "451       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "452       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "453       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "454       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "455       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "456       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "457       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "458       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "459       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "460       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "461       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "462       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "463       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "464       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "465       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "466       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "467       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "468       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "469       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "470       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "471       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "472       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "473       1794         1967   160  LGWFF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "474       1794         1967   160  LGWEF6A7×××××××××  长城汽车股份有限公司  LGW   2915   \n",
       "475       1755         1997   140  LGWEF5A5×××××××××  长城汽车股份有限公司  LGW   2700   \n",
       "476       1755         1997   140  LGWEF5A5×××××××××  长城汽车股份有限公司  LGW   2700   \n",
       "477       1745         1997   140  LGWFF5A5×××××××××  长城汽车股份有限公司  LGW   2700   \n",
       "478       1745         1997   140  LGWFF5A5×××××××××  长城汽车股份有限公司  LGW   2700   \n",
       "\n",
       "          长×宽×高[mm] brand_y    style  factory  \n",
       "0    4462x1857x1638     WEY  WEY VV5        2  \n",
       "1    4462x1857x1638     WEY  WEY VV5        2  \n",
       "2    4462x1857x1638     WEY  WEY VV5        2  \n",
       "3    4462x1857x1638     WEY  WEY VV5        2  \n",
       "4    4462x1857x1638     WEY  WEY VV5        2  \n",
       "5    4462x1857x1638     WEY  WEY VV5        2  \n",
       "6    4462x1857x1638     WEY  WEY VV5        2  \n",
       "7    4462x1857x1638     WEY  WEY VV5        2  \n",
       "8    4462x1857x1638     WEY  WEY VV5        2  \n",
       "9    4462x1857x1638     WEY  WEY VV5        2  \n",
       "10   4462x1857x1638     WEY  WEY VV5        2  \n",
       "11   4462x1857x1638     WEY  WEY VV5        2  \n",
       "12   4462x1857x1638     WEY  WEY VV5        2  \n",
       "13   4462x1857x1638     WEY  WEY VV5        2  \n",
       "14   4365x1814x1695      哈弗     哈弗H2       13  \n",
       "15   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "16   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "17   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "18   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "19   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "20   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "21   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "22   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "23   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "24   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "25   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "26   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "27   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "28   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "29   3898x1729x1621      哈弗     哈弗H1        8  \n",
       "..              ...     ...      ...      ...  \n",
       "449  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "450  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "451  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "452  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "453  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "454  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "455  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "456  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "457  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "458  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "459  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "460  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "461  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "462  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "463  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "464  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "465  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "466  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "467  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "468  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "469  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "470  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "471  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "472  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "473  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "474  4806x1975x1794      哈弗     哈弗H8       12  \n",
       "475  4650x1800x1755      哈弗     哈弗H5       30  \n",
       "476  4650x1800x1755      哈弗     哈弗H5       30  \n",
       "477  4650x1800x1745      哈弗     哈弗H5       26  \n",
       "478  4650x1800x1745      哈弗     哈弗H5       26  \n",
       "\n",
       "[479 rows x 17 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('长城_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LGWEE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>LGWFE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>LGWEE5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>LGWEE4A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>LGWEE6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>LGWED2A3×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>LGWFD2A3×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>LGWFE4A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>LGWEE2K5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>长城</td>\n",
       "      <td>长城C30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>LGWEE2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>长城</td>\n",
       "      <td>长城M2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>LGWEF4K5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>长城</td>\n",
       "      <td>长城C50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>LGWEF3K5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>长城</td>\n",
       "      <td>长城C50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>长城</td>\n",
       "      <td>凌傲</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>LGWED2A4×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>长城</td>\n",
       "      <td>长城C20R</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>LGWED2A2×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>长城</td>\n",
       "      <td>精灵</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>LGWEFEA5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>LGWFFEA5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>LGWEF7A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>WEY</td>\n",
       "      <td>WEY VV7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>LGWEF6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>LGWEF5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>LGWEF4A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>LGWEFEA5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>LGWEF5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6 Coupe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>LGWEF4A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6 Coupe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>LGWEFEA5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6 Coupe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>LGWEF6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6 Coupe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>LGWFF6A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6 Coupe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>LGWFFEA5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6 Coupe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>LGWEF7A6×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>336</th>\n",
       "      <td>LGWEF4A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>368</th>\n",
       "      <td>LGWFF6A6×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>369</th>\n",
       "      <td>LGWFF8A6×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>370</th>\n",
       "      <td>LGWFFGA6×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>LGWFFEA5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>412</th>\n",
       "      <td>LGWFF4A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433</th>\n",
       "      <td>LGWEFGA7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>434</th>\n",
       "      <td>LGWFFGA7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>435</th>\n",
       "      <td>LGWFF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>437</th>\n",
       "      <td>LGWEF6A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>LGWFF8A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>LGWEF8A7×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>475</th>\n",
       "      <td>LGWEF5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>477</th>\n",
       "      <td>LGWFF5A5×××××××××</td>\n",
       "      <td>长城汽车股份有限公司</td>\n",
       "      <td>哈弗</td>\n",
       "      <td>哈弗H5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   vin car_factory brand       style\n",
       "0    LGWEE6A5×××××××××  长城汽车股份有限公司   WEY     WEY VV5\n",
       "1    LGWFE6A5×××××××××  长城汽车股份有限公司   WEY     WEY VV5\n",
       "4    LGWEE5A5×××××××××  长城汽车股份有限公司   WEY     WEY VV5\n",
       "14   LGWEE4A4×××××××××  长城汽车股份有限公司    哈弗        哈弗H2\n",
       "15   LGWED2A4×××××××××  长城汽车股份有限公司    哈弗        哈弗H1\n",
       "37   LGWEE6A5×××××××××  长城汽车股份有限公司    哈弗        哈弗H4\n",
       "39   LGWED2A3×××××××××  长城汽车股份有限公司    哈弗        哈弗H1\n",
       "46   LGWFD2A3×××××××××  长城汽车股份有限公司    哈弗        哈弗H1\n",
       "53   LGWFE4A4×××××××××  长城汽车股份有限公司    哈弗        哈弗H2\n",
       "92   LGWEE2K5×××××××××  长城汽车股份有限公司    长城       长城C30\n",
       "97   LGWEE2A4×××××××××  长城汽车股份有限公司    长城        长城M2\n",
       "102  LGWEF4K5×××××××××  长城汽车股份有限公司    长城       长城C50\n",
       "103  LGWEF3K5×××××××××  长城汽车股份有限公司    长城       长城C50\n",
       "174  LGWED2A4×××××××××  长城汽车股份有限公司    长城          凌傲\n",
       "195  LGWED2A4×××××××××  长城汽车股份有限公司    长城      长城C20R\n",
       "205  LGWED2A2×××××××××  长城汽车股份有限公司    长城          精灵\n",
       "206  LGWEFEA5×××××××××  长城汽车股份有限公司    哈弗        哈弗H5\n",
       "208  LGWFFEA5×××××××××  长城汽车股份有限公司    哈弗        哈弗H5\n",
       "210  LGWEF7A7×××××××××  长城汽车股份有限公司   WEY     WEY VV7\n",
       "215  LGWEF6A5×××××××××  长城汽车股份有限公司    哈弗        哈弗H6\n",
       "221  LGWEF5A5×××××××××  长城汽车股份有限公司    哈弗        哈弗H6\n",
       "222  LGWEF4A5×××××××××  长城汽车股份有限公司    哈弗        哈弗H6\n",
       "228  LGWEFEA5×××××××××  长城汽车股份有限公司    哈弗        哈弗H6\n",
       "241  LGWEF5A5×××××××××  长城汽车股份有限公司    哈弗  哈弗H6 Coupe\n",
       "244  LGWEF4A5×××××××××  长城汽车股份有限公司    哈弗  哈弗H6 Coupe\n",
       "245  LGWEFEA5×××××××××  长城汽车股份有限公司    哈弗  哈弗H6 Coupe\n",
       "246  LGWEF6A5×××××××××  长城汽车股份有限公司    哈弗  哈弗H6 Coupe\n",
       "252  LGWFF6A5×××××××××  长城汽车股份有限公司    哈弗  哈弗H6 Coupe\n",
       "253  LGWFFEA5×××××××××  长城汽车股份有限公司    哈弗  哈弗H6 Coupe\n",
       "314  LGWEF7A6×××××××××  长城汽车股份有限公司    哈弗        哈弗H7\n",
       "336  LGWEF4A5×××××××××  长城汽车股份有限公司    哈弗        哈弗M6\n",
       "368  LGWFF6A6×××××××××  长城汽车股份有限公司    哈弗        哈弗H9\n",
       "369  LGWFF8A6×××××××××  长城汽车股份有限公司    哈弗        哈弗H9\n",
       "370  LGWFFGA6×××××××××  长城汽车股份有限公司    哈弗        哈弗H9\n",
       "411  LGWFFEA5×××××××××  长城汽车股份有限公司    哈弗        哈弗H6\n",
       "412  LGWFF4A5×××××××××  长城汽车股份有限公司    哈弗        哈弗H6\n",
       "433  LGWEFGA7×××××××××  长城汽车股份有限公司    哈弗        哈弗H8\n",
       "434  LGWFFGA7×××××××××  长城汽车股份有限公司    哈弗        哈弗H8\n",
       "435  LGWFF6A7×××××××××  长城汽车股份有限公司    哈弗        哈弗H8\n",
       "437  LGWEF6A7×××××××××  长城汽车股份有限公司    哈弗        哈弗H8\n",
       "443  LGWFF8A7×××××××××  长城汽车股份有限公司    哈弗        哈弗H8\n",
       "446  LGWEF8A7×××××××××  长城汽车股份有限公司    哈弗        哈弗H8\n",
       "475  LGWEF5A5×××××××××  长城汽车股份有限公司    哈弗        哈弗H5\n",
       "477  LGWFF5A5×××××××××  长城汽车股份有限公司    哈弗        哈弗H5"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
